SongAlbumRecording
Begin the Beguine Concert at the Palladium 175
   "Moonglow 486
   "Dancing in the Dark 1029
   "Centennial Celebration, A 1229
   "That Old Black Magic 1685
   "Great American Songwriters-Porter 1744
   "Sanitone Drycleaner Record 1871
   "Those Swingin' Days of the Big Bands 2379
   "Cole Porter Songbook - Anything Goes 2940
   "Collector's History of Classic Jazz 3510
   "Swingin' Big Bands 3576
   "Swing Era, Music of 1938-1939 5196
   "Swing Era, Music of 1944-1945 5352
   "Big Band Jazz 5478
   "Band with That Sound, The 6390
   "Ella Sings the Cole Porter Songbook 6984
   "Stan Kenton and His Orchestra 1943-1944 7755
   "Broadway Melody of 1940 7938
   "Basses Loaded 8183
   "'S Wonderful 8431
   "Best of Artie Shaw, The 10226
   "Artie Shaw 10256
   "1948 Transcription Performances, The 11188

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Begin the Beguine"